package com.ase.leetcode.组合两个表;

/**
 * @author gyhstart
 * @create 2021/3/18 - 15:32
 *
 * 表1: Person
 *
 * +-------------+---------+
 * | 列名         | 类型     |
 * +-------------+---------+
 * | PersonId    | int     |
 * | FirstName   | varchar |
 * | LastName    | varchar |
 * +-------------+---------+
 * PersonId 是上表主键
 * 表2: Address
 *
 * +-------------+---------+
 * | 列名         | 类型    |
 * +-------------+---------+
 * | AddressId   | int     |
 * | PersonId    | int     |
 * | City        | varchar |
 * | State       | varchar |
 * +-------------+---------+
 * AddressId 是上表主键
 *  
 *
 * 编写一个 SQL 查询，满足条件：无论 person 是否有地址信息，都需要基于上述两表提供 person 的以下信息：
 *
 * FirstName, LastName, City, State
 **/
public class Solution {

    /**
     * SELECT p.FirstName,p.LastName,a.City,a.State
     * FROM Person AS p LEFT JOIN Address AS a ON p.PersonId = a.PersonId
     */
}
